package Q2.pojo;

/**
 * SQL constant
 *
 * @author chisheng
 */
public class SQLConstant {

    /**
     * The SQL of insert a student
     */
    public static final String INSERT_STUDENT = "insert into student(id, no, name, age, birthday, photo) values(?, ?, ?, ?, ?, ?)";

    /**
     * The SQL of delete a student
     */
    public static final String DELETE_STUDENT = "delete from student where id=?";

    /**
     * The SQL of update a student
     */
    public static final String UPDATE_STUDENT = "update student set id=?, name=?, age=?, birthday=?, photo=?";

    /**
     * The SQL of query a student by specific no
     */
    public static final String QUERY_STUDENT = "select * from student where no=?";

}
